![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Parallel Server Option The Oracle Parallel Server option allows for two or more systems to access the same database tables by using a shared-disk mechanism. The option can be used both for increasing performance by adding more computers and for fault tolerance. If a hardware failure occurs in a parallel server configuration, the other members of the cluster continue running and automatically roll back any transactions that were pending on the failed system. The Parallel Server option is not available on all platforms; it requires special hardware and operating system support. Oracle Symmetric Replication Symmetric Replication is a new option introduced in Oracle version 7.2. It allows for replication of tables in a configuration so that all copies of the table can be modified. Data consistency is guaranteed through a complex set of rules. Full tables or subsets of tables can be replicated. Trusted Oracle Trusted Oracle is Oracles secure database management system product, designed to provide the high level of security required by companies and government agencies that handle sensitive data. Trusted Oracle is compatible with all the base Oracle products and supports all the functionality of standard Oracle. Trusted Oracle enforces mandatory access control across a wide range of secure operating systems. Trusted Oracle is not available on all platforms; it reduces performance because of the extra overhead associated with access control. Parallel Query Option The Parallel Query option is a set of features that allows a single query or operation to be divided among many processes. This feature can significantly improve performance in both multiprocessor and single-processor environments. Performance is increased by ensuring that the system CPUs stay busy doing work while other processes are waiting for I/Os to complete. The Parallel Query option is made up of the following components:
Server Manager The Oracle Server Manager provides a GUI tool for the administration of your Oracle RDBMS. Server Manager is available for Windows and Motif; a non-GUI, character-based version of this application is also available. Server Manager is intended to eventually replace SQL*DBA. Oracle Workgroup ServerWorkgroup Server is a powerful combination of the Oracle version 7 RDBMS and a complete set of point-and-click GUI tools that simplify database management. The Oracle version 7 Workgroup Server is part of the Workgroup/2000 suite of client/server tools. Workgroup Server comes preconfigured and is easy to install. The core RDBMS shipped with Workgroup Server is identical to the RDBMS shipped with the standard product. Some high-end add-ons (such as the Parallel Query option and the Distributed option) are not available on the Oracle Workgroup Server. Workgroup Server is available on all major PC servers, including NetWare, NetWare NT, Solaris x86, SCO UNIX, Novell NetWare, and OS/2. As the PC server platform continues to increase in performance and reliability, the Oracle Workgroup Server provides an unbeatable value. Here are some of the standard tools included with Workgroup Server:
The tools provided with Workgroup Server have the same look and feel whether your platform is a Windows NT system or UNIX system using X-Windows. Personal Oracle for WindowsThe newly released product, Personal Oracle for Windows, provides a version of the Oracle RDBMS for Microsoft Windows. With Personal Oracle for Windows, you can take Oracle with you on your notebook computer and use SQL*Net to connect to any other Oracle system on your network. Personal Oracle for Windows includes some of the same management tools shipped with Oracle Workgroup Server. Oracle Development ToolsOracle offers a rich set of development tools for use in GUI environments as well as character-based applications. These tools offer several approaches to application development based on the end users needs. Heres a list of the development tools available:
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |